SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweEnfermedades
AS
SELECT     idEnfermedad AS ID, Descripcion, NoCuentaAntiguedadParaLicencia
FROM         dbo.tb_Enfermedades
GO
GRANT SELECT ON  [dbo].[vweEnfermedades] TO [Informatica]
GRANT SELECT ON  [dbo].[vweEnfermedades] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vweEnfermedades] TO [PersonalDocenteDireccion]
GRANT UPDATE ON  [dbo].[vweEnfermedades] TO [PersonalDocenteDireccion]
GRANT SELECT ON  [dbo].[vweEnfermedades] TO [SoloVer]
GO
